{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","Extract","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":120,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":185,"n_cols":19,"rows_kept":185,"cut":false,"hidden":false,"merged":[[6,6,6,13],[66,7,66,8],[67,7,67,8],[68,7,68,8],[145,1,145,10],[6,2,6,5],[7,4,7,5],[20,4,20,5],[10,3,10,4],[12,3,12,4],[14,3,14,4],[15,3,15,4],[58,2,58,5],[54,2,54,6],[32,2,32,5],[24,7,24,8],[184,2,184,3],[184,4,184,5],[168,2,168,7],[174,2,174,3],[174,4,174,5],[175,2,175,3],[175,4,175,5],[170,2,172,5],[177,2,179,5],[181,2,181,3],[181,4,181,5],[182,2,182,3],[182,4,182,5],[148,9,148,10],[7,6,7,8],[20,6,20,8],[152,5,152,8],[50,2,50,6],[56,2,56,6],[60,7,60,8],[108,2,108,3],[107,2,107,3],[95,2,95,3],[52,2,52,6],[106,2,106,3],[60,2,60,5],[10,5,10,13],[71,5,71,6],[16,3,16,4],[158,3,158,4],[159,3,159,4],[157,8,157,9],[158,8,158,9],[17,3,17,4],[18,3,18,4],[19,3,19,4],[24,2,24,5],[150,9,150,10],[26,2,26,5],[43,2,43,5],[45,2,45,5],[34,2,34,5],[36,2,36,5],[38,2,38,5],[56,9,56,11],[156,2,156,4],[72,5,72,6],[157,3,157,4],[148,5,148,8],[153,5,153,8],[151,5,151,8],[150,5,150,8],[149,5,149,8],[157,14,157,16],[158,14,158,16],[159,14,159,16],[160,14,160,16],[153,9,153,10],[160,8,160,9],[171,8,171,18],[164,2,164,18],[166,2,166,18],[168,12,168,18],[159,8,159,9],[160,3,160,4],[151,9,151,10],[152,9,152,10],[156,6,156,8],[156,12,156,14],[156,15,156,16]]}
[]
[]
[]
[]
[]
[]
[null,null,"Application for a Scheme Loan",null,null,null,"Please only enter data in the yellow cells & clear data before proceeding"]
[]
[null,"General information"]
[]
[null,null,"Approved Housing Body Name:",null,null,{"$f":"I172","v":"Application has errors - DO NOT SUBMIT UNTIL CORRECTED"}]
[]
[null,null,"Name of Scheme:"]
[]
[null,null,"Scheme Address:"]
[]
[]
[]
[]
[]
[]
[null,"SECTION 1 - SCHEME COST, CALF SUMMARY & LOAN REQUIRED"]
[]
[]
[null,null,"Scheme type",null,null,null,{"$f":"IF(H25=\"\",\"CHECK►\",\"\")","v":"CHECK►"},null,null,"◄ Click & select from dropdown menu"]
[null,null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"PLEASE SELECT SCHEME TYPE\",\"\")","v":"PLEASE SELECT SCHEME TYPE"}]
[null,null,"Total number of Units",null,null,null,null,null,{"$f":"IF(H25=\"MTR/multiple props\",Lists!F38,0)","v":0}]
[]
[]
[]
[null,null,"Scheme cost data:"]
[]
[null,null,"The total scheme value (OMV) as provided by an independent valuer (€)",null,null,null,null,null,{"$f":"IF(H33=\"\",\"◄PLEASE ENTER TOTAL SCHEME OMV\",\"\")","v":"◄PLEASE ENTER TOTAL SCHEME OMV"}]
[]
[null,null,"Total purchase cost of Scheme/properties (€)",null,null,null,null,null,{"$f":"IF(H35=\"\",\"◄PLEASE ENTER TOTAL SCHEME PURCHASE COST\",\"\")","v":"◄PLEASE ENTER TOTAL SCHEME PURCHASE COST"}]
[]
[null,null,"Total other/additional costs (€)",null,null,null,null,null,{"$f":"IF(H37=\"\",\"◄PLEASE ENTER TOTAL ADDITIONAL COSTS - IF NIL ENTER 0\",\"\")","v":"◄PLEASE ENTER TOTAL ADDITIONAL COSTS - IF NIL ENTER 0"}]
[]
[null,null,"Total scheme cost",null,null,null,null,{"$f":"H37+H35","v":0}]
[]
[]
[null,null,"CALF funding summary"]
[]
[null,null,"Total CALF eligible cost (€)",null,null,null,null,null,{"$f":"IF(H44=\"\",\"◄PLEASE ENTER TOTAL CALF ELIGIBLE COST - IF NIL ENTER 0\",\"\")","v":"◄PLEASE ENTER TOTAL CALF ELIGIBLE COST - IF NIL ENTER 0"}]
[]
[null,null,"Total CALF capital subsidy( €)",null,null,null,null,null,{"$f":"IF(H46=\"\",\"◄PLEASE ENTER TOTAL CALF SUBSIDY - IF NIL ENTER 0\",\"\")","v":"◄PLEASE ENTER TOTAL CALF SUBSIDY - IF NIL ENTER 0"}]
[]
[]
[null,null,"Loan details"]
[]
[null,null,"Total scheme cost",null,null,null,null,{"$f":"H39","v":0}]
[]
[null,null,"Total CALF funding",null,null,null,null,{"$f":"H46","v":0}]
[]
[null,null,"Internal subsidy/equity (€)",null,null,null,null,null,null,{"$f":"IF(M57=0,\"PLEASE ENTER NO OF DRAWDOWNS\",\"\")","v":"PLEASE ENTER NO OF DRAWDOWNS"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(M57=0,\"▼\",\"\")","v":"▼"}]
[null,null,"Amount of total loan requested from the HFA (€)",null,null,null,null,{"$f":"H51-H53-H55","v":0},null,"No of loan drawdowns required",null,null,null,{"$f":"IF(M57=0,\"◄ENTER\",\"\")","v":"◄ENTER"}]
[]
[null,null,"Term of loan requested from the HFA (years)",null,null,null,{"$f":"IF(I59=\"PLEASE ENTER LOAN PERIOD\",\"CHECK\",\"\")","v":""},null,{"$f":"IF(No_of_years=\"\",\"◄PLEASE ENTER LOAN PERIOD\",\"\")","v":"◄PLEASE ENTER LOAN PERIOD"}]
[]
[null,null,"Interest rate basis",null,null,null,{"$f":"IF(H62=\"PLEASE SELECT INTEREST BASIS\",\"CHECK►\",\"\")","v":"CHECK►"},null,null,"◄Click & select from dropdown menu"]
[null,null,null,null,null,null,null,{"$f":"IF(H61=\"\",\"PLEASE SELECT INTEREST BASIS\",\"\")","v":"PLEASE SELECT INTEREST BASIS"}]
[]
[null,"SECTION 2 - OPERATING ASSUMPTIONS COMMON TO ALL UNITS"]
[]
[]
[null,null,"Management costs p.a.",null,null,null,null,"Income"]
[null,null,null,"Per unit p.a.:",null,null,{"$f":"IF(L68=\"Please enter a value\",\"CHECK\",\"\")","v":""},"Differential rent",null,"Per unit p.w.:",null,{"$f":"IF(K68=0,\"◄Please enter a value\",\"\")","v":"◄Please enter a value"}]
[null,null,null,"Per unit p.a.:",null,null,{"$f":"IF(K69=\"Please enter a value\",\"CHECK\",\"\")","v":""},"Total PAA income year 1",null,null,{"$f":"IF(J69=0,\"◄Please enter a value\",\"\")","v":"◄Please enter a value"}]
[null,null,null,"Per unit p.a.:"]
[null,null,null,"Per unit p.a.:"]
[null,null,{"$f":"IF(E72=0,\"CHECK\",\"\")","v":"CHECK"},"Total p.u.",{"$f":"SUM(E68:E71)","v":0},{"$f":"IF(C72=\"CHECK\",\"◄Cannot be zero\",\"\")","v":"◄Cannot be zero"}]
[null,null,{"$f":"IF(E73=0,\"CHECK\",\"\")","v":"CHECK"},"Total p.u.",{"$f":"E72*(Units+I27)","v":0},{"$f":"IF(C73=\"CHECK\",\"◄Cannot be zero\",\"\")","v":"◄Cannot be zero"}]
[]
[]
[]
[null,null,"Reactive and void maintenance costs p.a.",{"$f":"IF(G77=\"Please enter a value\",\"CHECK\",\"\")","v":""},"Per unit p.a.:",null,{"$f":"IF(F77=0,\"◄Please enter a value\",\"\")","v":"◄Please enter a value"}]
[null,null,null,null,"Total",{"$f":"F77*(Units+I27)","v":0}]
[]
[]
[]
[null,null,"Cyclical maintenance costs"]
[]
[null,null,"Annual or 5 yearly spend",null,{"$f":"IF(F84=\"\",\"CHECK►\",\"\")","v":"CHECK►"},null,"◄Click & select from dropdown menu",null,null,null,{"$f":"IF(E84=\"CHECK\",\"◄PLEASE SELECT\",\"\")","v":""}]
[]
[null,null,"Cyclical maintenance costs",null,"Per unit p.a.:",null,{"$f":"IF(F86=0,\"◄Please enter a value\",\"\")","v":"◄Please enter a value"}]
[null,null,null,null,"Total",{"$f":"F86*(Units+I27)","v":0}]
[]
[]
[]
[null,null,"Life cycle costs"]
[]
[null,null,"Sinking Fund or profile",null,{"$f":"IF(F93=\"\",\"CHECK►\",\"\")","v":"CHECK►"},null,"◄Click & select from dropdown menu",null,null,null,{"$f":"IF(E93=\"CHECK\",\"◄PLEASE SELECT\",\"\")","v":""}]
[null,null,{"$f":"IF($F$93=\"Profile\",\"\",\"Sinking Fund as % of Differential Rent\")","v":"Sinking Fund as % of Differential Rent"}]
[]
[null,null,{"$f":"IF($F$93=\"Sinking Fund\",\"\",\"Life cycle spend profile\")","v":"Life cycle spend profile"},null,{"$f":"IF($F$93=\"Sinking Fund\",\"\",\"Year\")","v":"Year"},{"$f":"IF($F$93=\"Sinking Fund\",\"\",\"Per Unit\")","v":"Per Unit"},{"$f":"IF($F$93=\"Sinking Fund\",\"\",\"Scheme Total\")","v":"Scheme Total"}]
[null,null,{"$f":"IF($F$93=\"Sinking Fund\",\"\",\"Life Cycle Spend in year\")","v":"Life Cycle Spend in year"},null,null,null,{"$f":"IF($F$93=\"Sinking Fund\",\"\",F97*(Units+$I$27))","v":0}]
[null,null,{"$f":"IF($F$93=\"Sinking Fund\",\"\",\"Life Cycle Spend in year\")","v":"Life Cycle Spend in year"},null,null,null,0]
[null,null,"Life Cycle Spend in year",null,null,null,0]
[null,null,"Life Cycle Spend in year",null,null,null,0]
[null,null,"Life Cycle Spend in year",null,null,null,0]
[null,null,"Life Cycle Spend in year",null,null,null,0]
[]
[]
[]
[null,null,"Other Costs p.a. - service charges, LPT etc not included in management costs"]
[null,null,null,null,"Per unit p.a.:"]
[null,null,null,null,"Per unit p.a.:"]
[null,null,null,null,"Per unit p.a.:"]
[null,null,null,null,"Total",{"$f":"SUM(F107:F109)*(Units+I27)","v":0}]
[]
[]
[null,{"$f":"IF(H25=\"MTR/multiple props\",\"SECTION 3 - MTR/MULTIPLE PROPERTY SCHEDULE\",\"SECTION 3 - PAA details\")","v":"SECTION 3 - PAA details"},null,null,null,{"$f":"IF(H25=\"MTR/multiple props\",\"PLEASE ONLY COMPLETE FOR MTR PORTFOLIOS OR MULTIPLE INDIVIDUAL PROPERTIES\",\"\")","v":""}]
[]
[null,"Property details",null,null,null,{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"Cost to be funded\")","v":""},null,null,{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"CALF details\")","v":""},null,null,null,"PAA details"]
[null,null,{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"Individual property address\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"Number of units\",\"Number of  bedrooms\")","v":"Number of units"},"Unit type",{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"Purchase price\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"Addtional costs to be funded\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"Total cost to be funded\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"CALF eligible cost\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"CALF % of eligible cost\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"CALF\")","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",\"CALF term\")","v":""},"Mkt rent per unit p.m.","PAA %","PAA pmnt per month","PAA pmnt p.a.","PAA review period","PAA term","DOE Approval status"]
[]
[null,null,null,null,{"$f":"IF(Section_2=\"DO NOT COMPLETE\",\"\",\"Click & select from drop down menu\")","v":"Click & select from drop down menu"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Section_2=\"DO NOT COMPLETE\",\"\",\"Click & select from drop down menu\")","v":"Click & select from drop down menu"},null,{"$f":"IF(Section_2=\"DO NOT COMPLETE\",\"\",\"Click & select from drop down menu\")","v":"Click & select from drop down menu"}]
[null,null,null,null,"▼",null,null,null,null,null,null,null,null,null,null,null,"▼",null,"▼"]
[null,null,null,null,null," ",null,{"$f":"IF($B$113=\"SECTION 3 - PAA details\",\"\",F120+G120)","v":""},null,null,{"$f":"IF($B$113=\"SECTION 3 - PAA details\",\"\",I120*J120)","v":""},null,null,null,{"$f":"M120*N120","v":0},{"$f":"O120*12","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($B$113=\"SECTION 3 - PAA details\",\"\",F121+G121)","v":""},null,null,{"$f":"IF($B$113=\"SECTION 3 - PAA details\",\"\",I121*J121)","v":""},null,null,null,{"$f":"M121*N121","v":0},{"$f":"O121*12","v":0}]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,null,null,"",null,null,"",null,null,null,0,0]
[null,null,null,null,null,{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",SUM(F120:F139))","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",SUM(G120:G139))","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",SUM(H120:H139))","v":""},{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",SUM(K120:K139))","v":""},null,{"$f":"IF(B113=\"SECTION 3 - PAA details\",\"\",SUM(K120:K139))","v":""},null,{"$f":"SUM(O120:O139)","v":0},null,{"$f":"SUM(O120:O139)","v":0},{"$f":"SUM(P120:P139)","v":0}]
[]
[]
[null,"SECTION 4  - ADDITIONAL INFORMATION"]
[null,"THIS SECTION MUST BE COMPLETED - FAILURE TO DO SO MAY DELAY YOUR APPLICATION"]
[]
[null,"When submitting your application please confirm in the boxes provide below that you have included the following information:"]
[]
[null,null,null,null,null,"Comments on other information submitted"]
[null,null,"Evidence of level of Availability Payments and CALF  -\nDOE conditional approval or completed agreement","No","◄Select from dropdown menu",null,null,null,null,{"$f":"+IF(D149=\"No\",IF(F149=\"\",\"◄Please explain why DOE approval(s) or completed agreement(s) are not provided\",\"\"),\"\")","v":"◄Please explain why DOE approval(s) or completed agreement(s) are not provided"}]
[null,null,"Scheme procured in accordance with EU procurement rules",null,"◄Select from dropdown menu",{"$f":"IF(D150=\"\",\"Please select scheme procurement status\",\"\")","v":"Please select scheme procurement status"}]
[null,null,"Valuation report of properties to be acquired","No","◄Select from dropdown menu",{"$f":"IF(D151=\"No\",\"Valuations MUST be provided\",\"\")","v":"Valuations MUST be provided"}]
[null,null,"Copy of scheme appraisal in Excel format","No","◄Select from dropdown menu",{"$f":"+IF(D152=\"No\",\"A scheme appraisal model MUST be provided\",\"\")","v":"A scheme appraisal model MUST be provided"}]
[null,null,"Structural survey of properties to be acquired. If structural surveys not provided please explain why","No","◄Select from dropdown menu",null,null,null,null,{"$f":"+IF(D153=\"No\",IF(F153=\"\",\"◄Please explain why structural surveys are not provided\",\"\"),\"\")","v":"◄Please explain why structural surveys are not provided"}]
[null,null,"Details of collateral warranties provided. If collateral warranty details have not been provided please explain why",null,"◄Select from dropdown menu",null,null,null,null,{"$f":"+IF(D154=\"\",IF(F154=\"\",\"◄Please explain why collateral warranty details have not been provided or select N/A if not applicable\",\"\"),\"\")","v":"◄Please explain why collateral warranty details have not been provided or select N/A if not applicable"}]
[]
[null,"SECTION 5 - CONTACT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"Single - details below"]
[null,null,"Borrower contact details",null,null,null,"Vendor contact details",null,null,"Single - details below","◄Select from dropdown menu",null,"Scheme access details",null,null,"Multiple - details provided separately",null,"◄Select from dropdown menu"]
[null,null,"Contact name :",null,null,{"$f":"IF(D158=\"\",\"◄Please complete\",\"\")","v":"◄Please complete"},"Contact name :",null,null,null,{"$f":"IF($J$157=\"Single - details below\",IF(I158=\"\",\"◄Please complete\",\"\"),\"\")","v":"◄Please complete"},null,"Contact name :",null,null,null,null,{"$f":"IF($P$157=\"Single - details below\",IF(O158=\"\",\"◄Please complete\",\"\"),\"\")","v":""}]
[null,null,"Job title :",null,null,{"$f":"IF(D159=\"\",\"◄Please complete\",\"\")","v":"◄Please complete"},"Job title :",null,null,null,{"$f":"IF($J$157=\"Single - details below\",IF(I159=\"\",\"◄Please complete\",\"\"),\"\")","v":"◄Please complete"},null,"Job title :",null,null,null,null,{"$f":"IF($P$157=\"Single - details below\",IF(O159=\"\",\"◄Please complete\",\"\"),\"\")","v":""}]
[null,null,"Telephone number :",null,null,"◄Please complete","Telephone number :",null,null,null,"◄Please complete",null,"Telephone number :",null,null,null,null,""]
[null,null,"Email address :",null,null,"◄Please complete","Email address :",null,null,null,"◄Please complete",null,"Email address :",null,null,null,null,""]
[]
[null,null,"SECTION 6 - DECLARATION"]
[]
[null,null,"I/we declare that the information in this application is accurate and complete in all material respects and that I/we am/are appropriately authorised by the Board to sign and apply for a newbuild/development facility from the HFA. I/we understand that completion of this application with deliberately or negligently inaccurate or misleading data or by unauthorised signatories will invalidate this application, any rights of the applicant, any document and any arrangement entered into as a result of this application. I/We confirm that the underlying transactions for the acquisition of the property/properties will be entered into on commercial arms-length terms and that none of the subject contractual arrangements will be with a party which is a “connected person” (within the meaning of s. 10 of the Taxes Consolidation Act, 1997) of an officer or employee of the Approved Housing Body."]
[]
[null,null,"NOTICE: Under the Credit Reporting Act 2013 lenders are required to provide personal and credit information for credit applications and credit agreements of €500 and above to the Central Credit Register. This information may be used by other lenders when making decisions on your credit applications and credit agreements."]
[]
[null,null,"In submitting this application for an Individual Scheme Loan I/we confirm that the information contained within this application is materially  correct and accurate, and I/we also confirm that I/we am/are not aware of any known reasons that may preclude us from entering into a loan arrangement with the Housing Finance Agency plc.",null,null,null,null,null,"No","◄Select from dropdown menu",null,null,{"$f":"IF(I169=\"No\",\"DO NOT SUBMIT IF THIS DECLARATION IS NOT POSITIVE\",\"\")","v":"DO NOT SUBMIT IF THIS DECLARATION IS NOT POSITIVE"}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Lists!H53=0,\"Application is OK to submit\",\"Application has errors - DO NOT SUBMIT UNTIL CORRECTED\")","v":"Application has errors - DO NOT SUBMIT UNTIL CORRECTED"}]
[]
[null,null,"Signature 1"]
[null,null,"Name :"]
[null,null,"Job title :"]
[]
[]
[]
[]
[null,null,"Signature 2, if necessary"]
[null,null,"Name :"]
[null,null,"Job title :"]
[]
[null,null,"Application date :"]

{"sheet":"Extract","index":1,"n_rows":176,"n_cols":3,"rows_kept":176,"cut":false,"hidden":true,"merged":[]}
["Housing Finance Agency plc."]
["Extracts for Individual Loan Assessment Model"]
[]
[{"$f":"+Inputs!B9","v":"General information"}]
[]
[]
["Approved Housing Body Name:",null,{"$f":"Inputs!D11","v":0}]
[]
["Name of Scheme:",null,{"$f":"Inputs!D13","v":0}]
[]
["Scheme Address:",null,{"$f":"Inputs!D16","v":0}]
[null,null,{"$f":"Inputs!D17","v":0}]
[null,null,{"$f":"Inputs!D18","v":0}]
[null,null,{"$f":"Inputs!D19","v":0}]
[null,null,{"$f":"Inputs!D20","v":0}]
[]
[]
["SECTION 1 - SCHEME COSTS AND LOAN DATA"]
[]
["Number of Units",null,{"$f":"Inputs!H27","v":0}]
[]
["The total scheme value as provided by an independent valuer",null,{"$f":"Inputs!H33","v":0}]
[]
["Total Purchase/Build Cost of Scheme",null,{"$f":"Inputs!H35","v":0}]
[]
["Capital Subsidy from external sources",null,{"$f":"Inputs!H46","v":0}]
["Internal Capital Subsidy or Equity",null,{"$f":"Inputs!H51","v":0}]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"Inputs!H57","v":0}]
[]
["The term of the loan requested by the HFA",null,{"$f":"Inputs!H59","v":0}]
[]
["SECTION 2 - YEAR 1 INCOME AND EXPENDITURE DATA"]
[]
[]
["Total Availability Payment per annum",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Term of the Payment and Availability Agreement",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Years between \"Adjustments\" to AP per Schedule 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Market Rent per Year",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Differential rent per week per tenant",null,{"$f":"Inputs!F65","v":0}]
["Differential Rent per Year",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Voids & Bad Debts on Availability Payment",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Voids & Bad Debts on Differential Rent",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Input details of any other income e.g. grants","per unit",{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Other Income total in year 1","Total",{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Management and Maintenance Costs"]
[]
["Management costs"]
["Input details of management costs","per unit",{"$f":"Inputs!E68","v":0}]
["Management costs total in year 1","Total",{"$f":"Inputs!E73","v":0}]
[]
["Reactive and void maintenance costs"]
["Input details of reactive and voids maintenance costs","per unit",{"$f":"Inputs!F77","v":0}]
["Reactive and void maintenance costs total in year 1","Total",{"$f":"Inputs!F78","v":0}]
[]
["Cyclical maintenance costs"]
["Input details of cyclical maintenance costs per unit","per unit",{"$f":"Inputs!F86","v":0}]
["Cyclical maintenance costs total in year 1","Total",{"$f":"Inputs!F87","v":0}]
[]
["Choose if cyclical maintenance costs are assumed to be incurred annually or at 5 yearly intervals",null,{"$f":"Inputs!F84","v":0}]
[]
["Sinking Fund"]
["Sinking Fund as % of Differential Rent",null,{"$f":"Inputs!F94","v":0}]
["Cash or Reserve Movement ?",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Life cycle costs","Year","Total"]
["Life Cycle Spend in year",{"$f":"Inputs!E97","v":0},{"$f":"Inputs!F97","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!E98","v":0},{"$f":"Inputs!F98","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!E99","v":0},{"$f":"Inputs!F99","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!E100","v":0},{"$f":"Inputs!F100","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!E101","v":0},{"$f":"Inputs!F101","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!E102","v":0},{"$f":"Inputs!F102","v":0}]
[]
["Other Costs"]
["Input details of any other costs e.g. service charges paid","per unit",{"$f":"Inputs!F107","v":0}]
[{"$f":"A81&\" total in year 1\"","v":"Other Costs total in year 1"},"Total",{"$f":"Inputs!F110","v":0}]
[]
["SECTION 3 - ECONOMIC ASSUMPTIONS"]
[]
["Discount rate used for NPV",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Interest Rate % per year",null,"%"]
["Input the interest rate assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the interest rate assumed in years 16 to \"&No_of_years","v":"Input the interest rate assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Consumer Price Index Rental Sub-Indices Input",null,"%"]
["Input the CPI rents indice assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the CPI rents indice assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the CPI rents indice assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the CPI rents indice assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the CPI rents indice assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the CPI rents indice assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the CPI rents indice assumed in years 16 to \"&No_of_years","v":"Input the CPI rents indice assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Rent increases on Differential Rent",null,"%"]
["Input the differential rent increase assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the differential rent increase assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the differential rent increase assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the differential rent increase assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the differential rent increase assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the differential rent increase assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the differential rent increase assumed in years 16 to \"&No_of_years","v":"Input the differential rent increase assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Other Income % increase per year",null,"%"]
["Input the interest rate assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the interest rate assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the interest rate assumed in years 16 to \"&No_of_years","v":"Input the interest rate assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Management Cost  % increase per year",null,"%"]
["Input the management costs inflation assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the management costs inflation assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the management costs inflation assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the management costs inflation assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the management costs inflation assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the management costs inflation assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the management costs inflation assumed in years 16 to \"&No_of_years","v":"Input the management costs inflation assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Maintenance Cost  % increase per year",null,"%"]
["Input the maintenance costs inflation assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the maintenance costs inflation assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the maintenance costs inflation assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the maintenance costs inflation assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the maintenance costs inflation assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the maintenance costs inflation assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the maintenance costs inflation assumed in years 16 to \"&No_of_years","v":"Input the maintenance costs inflation assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
["Other Cost % increase per year",null,"%"]
["Input the other costs inflation assumed in year 1",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the other costs inflation assumed in year 2",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the other costs inflation assumed in year 3",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the other costs inflation assumed in year 4",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the other costs inflation assumed in year 5",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
["Input the other costs inflation assumed in years 6 to 15",null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Input the other costs inflation assumed in years 16 to \"&No_of_years","v":"Input the other costs inflation assumed in years 16 to "},null,{"$f":"Inputs!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[{"$f":"+Inputs!B143","v":"SECTION 4  - ADDITIONAL INFORMATION"}]
[]
[{"$f":"+Inputs!C149","v":"Evidence of level of Availability Payments and CALF  -\nDOE conditional approval or completed agreement"},{"$f":"+Inputs!D149","v":"No"},{"$f":"+Inputs!F149","v":0}]
[{"$f":"+Inputs!#REF!","v":{"$error":"#REF!"}},{"$f":"+Inputs!#REF!","v":{"$error":"#REF!"}},{"$f":"+Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+Inputs!C151","v":"Valuation report of properties to be acquired"},{"$f":"+Inputs!D151","v":"No"},{"$f":"+Inputs!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+Inputs!C153","v":"Structural survey of properties to be acquired. If structural surveys not provided please explain why"},{"$f":"+Inputs!D153","v":"No"},{"$f":"+Inputs!F153","v":0}]
[]
[]
[{"$f":"+Inputs!B156","v":"SECTION 5 - CONTACT INFORMATION"}]
[]
[{"$f":"+Inputs!C158","v":"Contact name :"},{"$f":"+Inputs!D158","v":0}]
[{"$f":"+Inputs!C159","v":"Job title :"},{"$f":"+Inputs!D159","v":0}]
[{"$f":"+Inputs!C160","v":"Telephone number :"},{"$f":"+Inputs!D160","v":0}]
[{"$f":"+Inputs!C161","v":"Email address :"},{"$f":"+Inputs!D161","v":0}]
[]
[{"$f":"+Inputs!G158","v":"Contact name :"},{"$f":"Inputs!I158","v":0}]
[{"$f":"+Inputs!G159","v":"Job title :"},{"$f":"Inputs!I159","v":0}]
[{"$f":"+Inputs!G160","v":"Telephone number :"},{"$f":"Inputs!I160","v":0}]
[{"$f":"+Inputs!G161","v":"Email address :"},{"$f":"Inputs!I161","v":0}]
[]
[]
[{"$f":"+Inputs!C163","v":"SECTION 6 - DECLARATION"}]
[]
[{"$f":"+Inputs!C169","v":"In submitting this application for an Individual Scheme Loan I/we confirm that the information contained within this application is materially  correct and accurate, and I/we also confirm that I/we am/are not aware of any known reasons that may preclude us from entering into a loan arrangement with the Housing Finance Agency plc."},null,{"$f":"+Inputs!I169","v":"No"}]

{"sheet":"Lists","index":2,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"SinkingFund"]
[null,"Sinking fund"]
[null,"Profile"]
[]
[null,"TimePeriod"]
[null,"Annual"]
[null,"Five yearly"]
[]
[null,"YearsAdjustments"]
[null,3]
[null,4]
[null,5]
[]
[null,"Type of scheme"]
[null,"Standard acquisition",null,null,null,"Unit check",null,"Errors"]
[null,"Design & Build",null,null,null,{"$f":"IF(Inputs!H120>0,1,0)","v":1},null,{"$f":"IF(Inputs!G25=\"CHECK\",1,0)","v":0},null,null,{"$f":"IF(Inputs!D158=\"\",1,0)","v":1},null,null,{"$f":"AND(Inputs!D149=\"No\",Inputs!F149=\"\")","v":true},{"$f":"IF(N18=TRUE,1,0)","v":1}]
[null,"MTR/multiple props",null,null,null,{"$f":"IF(Inputs!H121>0,1,0)","v":1},null,{"$f":"IF(Inputs!G59=\"CHECK\",1,0)","v":0},null,null,{"$f":"IF(Inputs!D159=\"\",1,0)","v":1},null,null,{"$f":"IF(Inputs!D151=\"No\",1,0)","v":1},{"$f":"N19","v":1}]
[null,"Refinancing",null,null,null,{"$f":"IF(Inputs!H122>0,1,0)","v":1},null,{"$f":"IF(Inputs!G61=\"CHECK\",1,0)","v":0},null,null,{"$f":"IF(Inputs!D160=\"\",1,0)","v":1},null,null,{"$f":"IF(Inputs!D152=\"No\",1,0)","v":1},{"$f":"N20","v":1}]
[null,null,null,null,null,{"$f":"IF(Inputs!H123>0,1,0)","v":1},null,{"$f":"IF(Inputs!G68=\"CHECK\",1,0)","v":0},null,null,{"$f":"IF(Inputs!D161=\"\",1,0)","v":1},{"$f":"SUM(K18:K21)","v":4},null,{"$f":"AND(Inputs!D153=\"No\",Inputs!F153=\"\")","v":true},{"$f":"IF(N21=TRUE,1,0)","v":1}]
[null,"Interest basis",null,null,null,{"$f":"IF(Inputs!H124>0,1,0)","v":1},null,{"$f":"IF(Inputs!G69=\"CHECK\",1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(O18:O21)","v":4}]
[null,"Variable rate",null,null,null,{"$f":"IF(Inputs!H125>0,1,0)","v":1},null,{"$f":"IF(Inputs!J151=\"◄Please select to confirm that a valuation report has been provided\",1,0)","v":0}]
[null,"Fixed 10 yrs",null,null,null,{"$f":"IF(Inputs!H126>0,1,0)","v":1},null,{"$f":"IF(Inputs!J152=\"◄Please select to confirm that an Excel-based appraisal has been provided\",1,0)","v":0}]
[null,"Fixed 15 yrs",null,null,null,{"$f":"IF(Inputs!H127>0,1,0)","v":1},null,{"$f":"IF(Inputs!M57=0,1,0)","v":1}]
[null,"Fixed 20 yrs",null,null,null,{"$f":"IF(Inputs!H128>0,1,0)","v":1},null,{"$f":"IF(Inputs!F86=0,1,0)","v":1},null,null,{"$f":"IF(Inputs!I158=\"\",1,0)","v":1}]
[null,"Fixed 25 yrs",null,null,null,{"$f":"IF(Inputs!H129>0,1,0)","v":1},null,{"$f":"IF(Inputs!C72=\"CHECK\",1,0)","v":1},null,null,{"$f":"IF(Inputs!I159=\"\",1,0)","v":1}]
[null,"Fixed 30 yrs",null,null,null,{"$f":"IF(Inputs!H130>0,1,0)","v":1},null,{"$f":"IF(Inputs!C73=\"CHECK\",1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF(Inputs!H131>0,1,0)","v":1},null,{"$f":"IF(Inputs!D77=\"CHECK\",1,0)","v":0}]
[null,"Property type",null,null,null,{"$f":"IF(Inputs!H132>0,1,0)","v":1},null,{"$f":"IF(Inputs!E84=\"CHECK\",1,0)","v":0}]
[null,"Detached house",null,null,null,{"$f":"IF(Inputs!H133>0,1,0)","v":1},null,{"$f":"IF(Inputs!E93=\"CHECK\",1,0)","v":0},null,null,{"$f":"IF(Inputs!I160=\"\",1,0)","v":1}]
[null,"Semi-detached house",null,null,null,{"$f":"IF(Inputs!H134>0,1,0)","v":1},null,{"$f":"IF(Inputs!J149=Lists!N32,1,0)","v":1},null,null,{"$f":"IF(Inputs!I161=\"\",1,0)","v":1},{"$f":"SUM(K26:K32)","v":4},null,"◄Please explain why DOE approval(s) or completed agreement(s) are not provided"]
[null,"Terraced house",null,null,null,{"$f":"IF(Inputs!H135>0,1,0)","v":1},null,{"$f":"IF(Inputs!F150=Lists!N33,1,0)","v":1},null,null,null,null,null,"Please select scheme procurement status"]
[null,"Apartment",null,null,null,{"$f":"IF(Inputs!H136>0,1,0)","v":1},null,{"$f":"IF(Inputs!D151=\"No\",1,0)","v":1}]
[null,"Duplex",null,null,null,{"$f":"IF(Inputs!H137>0,1,0)","v":1},null,{"$f":"IF(Inputs!D152=\"No\",1,0)","v":1}]
[null,"Other",null,null,null,{"$f":"IF(Inputs!H138>0,1,0)","v":1},null,{"$f":"IF(Inputs!J153=Lists!N36,1,0)","v":1},null,null,null,null,null,"◄Please explain why structural surveys are not provided"]
[null,null,null,null,null,{"$f":"IF(Inputs!H139>0,1,0)","v":1},null,{"$f":"IF(Inputs!J154=Lists!N37,1,0)","v":1},null,null,null,null,null,"◄Please explain why collateral warranty details have not been provided or select N/A if not applicable"]
[null,"DOE status",null,null,null,{"$f":"SUM(F17:F37)","v":20},null,{"$f":"IF(Inputs!F158=Lists!N38,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"Conditional",null,null,null,null,null,{"$f":"IF(Inputs!F159=Lists!N39,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"Awaited",null,null,null,null,null,{"$f":"IF(Inputs!F160=Lists!N40,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"Agmnt signed",null,null,null,null,null,{"$f":"IF(Inputs!F161=Lists!N41,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,null,null,null,null,null,null,{"$f":"IF(Inputs!K158=Lists!N42,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"Yes/No",null,null,null,null,null,{"$f":"IF(Inputs!K159=Lists!N43,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"Yes",null,null,null,null,null,{"$f":"IF(Inputs!K160=Lists!N44,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"No",null,null,null,null,null,{"$f":"IF(Inputs!K161=Lists!N45,1,0)","v":1},null,null,null,null,null,"◄Please complete"]
[null,"N/A",null,null,null,null,null,{"$f":"IF(Inputs!R158=Lists!N46,1,0)","v":0},null,null,null,null,null,"◄Please complete"]
[null,null,null,null,null,null,null,{"$f":"IF(Inputs!R159=Lists!N47,1,0)","v":0},null,null,null,null,null,"◄Please complete"]
[null,"Access details",null,null,null,null,null,{"$f":"IF(Inputs!R160=Lists!N48,1,0)","v":0},null,null,null,null,null,"◄Please complete"]
[null,"Multiple - details provided separately",null,null,null,null,null,{"$f":"IF(Inputs!R161=Lists!N49,1,0)","v":0},null,null,null,null,null,"◄Please complete"]
[null,"Single - details below",null,null,null,null,null,{"$f":"IF(Inputs!I169=\"No\",1,0)","v":1}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H18:H52)","v":19}]